Diagram Prescription

Defincja diagramu Prescription

Name

Prescription

Code

Prescription

Comment

 


Lista tabel diagramu

Name

Code

ActiveIngredient

ActiveIngredient

BazylImport

BazylImport

Contract

Contract

Country

Country

DictionaryValue

DictionaryValue

Drug

Drug

DrugAccessCategory

DrugAccessCategory

DrugAccessCategoryText

DrugAccessCategoryText

DrugActiveSubst

DrugActiveSubst

DrugComplexProductSet

DrugComplexProductSet

DrugCostGroupICD

DrugCostGroupICD

DrugDBType

DrugDBType

DrugInteraction

DrugInteraction

DrugProducer

DrugProducer

DrugSynonym

DrugSynonym

Event

Event

ICD

ICD

IndividualMedicalPractice

IndividualMedicalPractice

Insurer

Insurer

InteractionStrength

InteractionStrength

InteractionStrengthText

InteractionStrengthText

LPersonnelDrug

LPersonnelDrug

LVisitRequestedDrug

LVisitRequestedDrug

MedicalProduct

MedicalProduct

Patient

Patient

Personnel

Personnel

Prescription

Prescription

PrescriptionDrug

PrescriptionDrug

PrescriptionDrugActiveSubst

PrescriptionDrugActiveSubst

PrescriptionFavouriteDrug

PrescriptionFavouriteDrug

PrescriptionNo

PrescriptionNo

PrescriptionNoSet

PrescriptionNoSet

PrescriptionPermission

PrescriptionPermission

PrescriptionStatus

PrescriptionStatus

PrescriptionStatusText

PrescriptionStatusText

ReimbursedDrug

ReimbursedDrug

ReimbursedDrugCostGroup

ReimbursedDrugCostGroup

ReimbursedDrugImport

ReimbursedDrugImport

ReimbursedDrugType

ReimbursedDrugType

ReimbursedDrugTypeText

ReimbursedDrugTypeText

SysFct

SysFct

Visit

Visit


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_7090

R_7090

PrescriptionNoSet

PrescriptionNo

PrescriptionNoSetID

 

 

R_7092

R_7092

Personnel

PrescriptionNoSet

PersonID

 

 

R_7093

R_7093

PrescriptionNo

Prescription

PrescriptionNo

 

 

R_7094

R_7094

PrescriptionPermission

Prescription

PrescriptionPermissionID

 

 

R_7096

R_7096

Event

Prescription

EventID

 

 

R_7099

R_7099

Insurer

Prescription

InsurID

 

 

R_8000

R_8000

Country

Prescription

CountryID

 

 

R_8002

R_8002

Prescription

PrescriptionDrug

PrescriptionID

 

 

R_8003

R_8003

DrugDBType

Drug

DrugDBTypeID

 

 

R_8080

R_8080

Personnel

LPersonnelDrug

PersonID

 

 

R_8480

R_8480

ReimbursedDrugType

ReimbursedDrugTypeText

ReimbursedDrugTypeID

 

 

R_8481

R_8481

ReimbursedDrugType

ReimbursedDrug

ReimbursedDrugTypeID

 

 

R_8482

R_8482

ReimbursedDrug

ReimbursedDrugCostGroup

ReimbursedDrugID

 

 

R_8886

R_8886

Personnel

IndividualMedicalPractice

PersonID

 

 

R_8887

R_8887

SysFct

Prescription

PrescriptionTypeID

 

 

R_8888

R_8888

PrescriptionNoSet

Prescription

PrescriptionNoSetID

 

 

R_8930

R_8930

DrugProducer

Drug

DrugProducerID

 

 

R_8975

R_8975

DrugAccessCategory

DrugAccessCategoryText

DrugAccessCategoryID

 

 

R_8976

R_8976

DrugAccessCategory

Drug

DrugAccessCategoryID

 

 

R_8977

R_8977

DrugAccessCategory

Prescription

DrugAccessCategoryID

 

 

R_8978

R_8978

DrugAccessCategory

PrescriptionNoSet

DrugAccessCategoryID

 

 

R_9293

R_9293

InteractionStrength

InteractionStrengthText

InteractionStrengthID

 

 

R_9294

R_9294

InteractionStrength

DrugInteraction

InteractionStrengthID

 

 

R_9295

R_9295

Drug

DrugInteraction

DrugDBTypeID2; DrugNo2

 

 

R_9296

R_9296

Drug

DrugInteraction

DrugDBTypeID1; DrugNo1

 

 

R_9472

R_9472

DictionaryValue

Drug

ForceID

 

 

R_9957

R_9957

DictionaryValue

PrescriptionNoSet

PrescKindID

 

 

R_9958

R_9958

DictionaryValue

Prescription

PrescKindID

 

 

R_10001

R_10001

Contract

PrescriptionNoSet

ContractID

 

 

R_10030

R_10030

Drug

DrugActiveSubst

DrugDBTypeID; DrugNo

 

 

R_10031

R_10031

DrugActiveSubst

PrescriptionDrugActiveSubst

DrugActiveSubstID

 

 

R_10032

R_10032

PrescriptionDrug

PrescriptionDrugActiveSubst

PrescriptionDrugID

 

 

R_10121

R_10121

Drug

DrugCostGroupICD

DrugDBTypeID; DrugNo

 

 

R_10122

R_10122

DrugDBType

DrugCostGroupICD

DrugDBTypeID

 

 

R_10123

R_10123

ICD

DrugCostGroupICD

ICDID

 

 

R_10124

R_10124

Personnel

PrescriptionFavouriteDrug

PersonnelID

 

 

R_10126

R_10126

Drug

PrescriptionFavouriteDrug

DrugDBTypeID; DrugNo

 

 

R_10127

R_10127

DrugDBType

PrescriptionFavouriteDrug

DrugDBTypeID

 

 

R_10128

R_10128

DictionaryValue

PrescriptionFavouriteDrug

PatientDosageID

 

 

R_10129

R_10129

DictionaryValue

PrescriptionFavouriteDrug

GeneralDosageID

 

 

R_10290

R_10290

PrescriptionStatus

PrescriptionStatusText

PrescriptionStatusID

 

 

R_10291

R_10291

PrescriptionStatus

Prescription

PrescriptionStatusID

 

 

R_10348

R_10348

Visit

LVisitRequestedDrug

VisitID

 

 

R_10349

R_10349

Drug

LVisitRequestedDrug

DrugDBTypeID; DrugNo